Overview

Dataset statistics

Number of variables103
Number of observations508031
Missing cells20901650
Missing cells (%)39.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory399.2 MiB
Average record size in memory824.0 B

Variable types

CAT45
UNSUPPORTED42
NUM8
BOOL8

Reproduction

Analysis started2020-06-10 08:08:28.195435
Analysis finished2020-06-10 08:17:08.617721
Duration8 minutes and 40.42 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

ACCOUNT_BALANCE has constant value "0" Constant
ACCOUNT_PURPOSE has constant value "DIARIO" Constant
ACCOUNT_SEGMENT has constant value "1" Constant
BALANCE_DATE has constant value "2018" Constant
BENEFICIARY_FLAG has constant value "N" Constant
BLOCKED_REASON has constant value "HIGH ACTIVITY" Constant
BLOCKED_TYPE has constant value "Y" Constant
CHANNEL_OF_OPENING has constant value "INTERNET" Constant
CREDIT_LIMIT has constant value "2000" Constant
CREDIT_TURNOVER has constant value "Y" Constant
CURRENCY_CODE has constant value "EUR" Constant
CUSTOMER_SEGMENT_1 has constant value "1" Constant
CUSTOMER_STATUS_CODE has constant value "1" Constant
CUSTOMER_TYPE_CODE has constant value "P" Constant
DEBIT_TRUNOVER has constant value "N" Constant
EMPLOYMENT_STATUS has constant value "Desempleado" Constant
LIFE_INS_CONTRACT_DURATION has constant value "0" Constant
OCCUPATION has constant value "Camarero" Constant
ORG_UNIT_CODE has constant value "RET" Constant
OVERDRAFT_LIMIT has constant value "0" Constant
PAYMENT_FREQ has constant value "Diario" Constant
PAYMENT_METHOD has constant value "Transferencia" Constant
PERIODIC_LOAN_AMOUNT has constant value "0" Constant
REPORTING_REGION has constant value "Y" Constant
RISK_CATEGORY has constant value "PEP" Constant
RISK_SCORE has constant value "100" Constant
TOTAL_LOANS_BASE has constant value "200" Constant
ISSUE_DATE has a high cardinality: 24217 distinct values High cardinality
ORIGINATION_DATE has a high cardinality: 24218 distinct values High cardinality
PRODUCT_SOURCE_TYPE_CODE has a high cardinality: 10966 distinct values High cardinality
TXN_SOURCE_TYPE_CODE has a high cardinality: 9030 distinct values High cardinality
PRIME_BRANCH_ID is highly correlated with BRANCH_ID and 1 other fieldsHigh correlation
BRANCH_ID is highly correlated with PRIME_BRANCH_ID and 1 other fieldsHigh correlation
RELATIONSHIP_MGR_ID is highly correlated with BRANCH_ID and 1 other fieldsHigh correlation
TXN_CHANNEL_CODE is highly correlated with CHECK_ACCOUNT_NUMBERHigh correlation
CHECK_ACCOUNT_NUMBER is highly correlated with TXN_CHANNEL_CODEHigh correlation
COUNTRY_OF_ORIGIN is highly correlated with CITY and 2 other fieldsHigh correlation
CITY is highly correlated with COUNTRY_OF_ORIGIN and 2 other fieldsHigh correlation
COUNTRY_OF_RESIDENCE is highly correlated with CITY and 2 other fieldsHigh correlation
DATE_OPENED is highly correlated with DATE_CLOSEDHigh correlation
DATE_CLOSED is highly correlated with DATE_OPENEDHigh correlation
GENDER_CODE is highly correlated with CITY and 2 other fieldsHigh correlation
ACCOUNT_ON_HOLD_FLAG has 508031 (100.0%) missing values Missing
ACCOUNT_STATUS_CODE has 508031 (100.0%) missing values Missing
ANN_PREMIUM_AMT has 508031 (100.0%) missing values Missing
BUSINESS_SEGMENT_1 has 508031 (100.0%) missing values Missing
CANCELLED_DATE has 508031 (100.0%) missing values Missing
CASH_SURR_VALUE has 508031 (100.0%) missing values Missing
COLLECTED_BALANCE has 508031 (100.0%) missing values Missing
COMMENTS has 508031 (100.0%) missing values Missing
COMPANY_NAME has 508031 (100.0%) missing values Missing
CUSTOMER_INITIATED_CLOSURE has 508031 (100.0%) missing values Missing
CUSTOMER_ID has 508031 (100.0%) missing values Missing
CUSTOMER_TYPE has 508031 (100.0%) missing values Missing
DEATH_BENEFIT_AMT has 508031 (100.0%) missing values Missing
DELAYED_ACCOUNT_FLAG has 508031 (100.0%) missing values Missing
DELIVERY_INSTRUCTIONS has 508031 (100.0%) missing values Missing
EMPLOYEE_NUMBER has 508031 (100.0%) missing values Missing
ERROR_CORRECT_FLAG has 508031 (100.0%) missing values Missing
GENDER_CODE has 54847 (10.8%) missing values Missing
GROSS_PREM_TTD has 508031 (100.0%) missing values Missing
HOLDING_BANK_NAME has 508031 (100.0%) missing values Missing
INST_PREMIUM_AMT has 508031 (100.0%) missing values Missing
LANGUAGE_PREF_CODE has 508031 (100.0%) missing values Missing
MATURITY_DATE has 508031 (100.0%) missing values Missing
OTHER_HOLD_AMOUNT has 508031 (100.0%) missing values Missing
PERSON_TITLE has 508031 (100.0%) missing values Missing
PRIMARY_CARD_ID has 508031 (100.0%) missing values Missing
PRIMARY_CUSTOMER_CATEGORY_CODE has 508031 (100.0%) missing values Missing
REGISTERED_NUMBER has 508031 (100.0%) missing values Missing
RUN_TIMESTAMP has 508031 (100.0%) missing values Missing
SALARY_LODGED_FLAG has 508031 (100.0%) missing values Missing
SENT_CORRESPONDENCE_FLAG has 508031 (100.0%) missing values Missing
SETTLEMENT_BANK_NAME has 508031 (100.0%) missing values Missing
SETTLEMENT_TYPE has 508031 (100.0%) missing values Missing
SINGLE_PREMIUM_TOTAL has 508031 (100.0%) missing values Missing
SOURCE_SYSTEM_CODE has 508031 (100.0%) missing values Missing
SUB_DIVISION has 508031 (100.0%) missing values Missing
SUM_INSURED has 508031 (100.0%) missing values Missing
TO_DATE has 508031 (100.0%) missing values Missing
TOTAL_DEPOSITS_BASE has 508031 (100.0%) missing values Missing
TRANSACTION_LOCATION has 508031 (100.0%) missing values Missing
TURNOVER_FROM_DATE has 508031 (100.0%) missing values Missing
TURNOVER_TO_DATE has 508031 (100.0%) missing values Missing
ISSUE_DATE is uniformly distributed Uniform
ORIGINATION_DATE is uniformly distributed Uniform
ACCOUNT_SOURCE_UNIQUE_ID has unique values Unique
SOURCE_TXN_NUM has unique values Unique
SOURCE_TXN_UNIQUE_ID has unique values Unique
ACCOUNT_ON_HOLD_FLAG is an unsupported type, check if it needs cleaning or further analysis Unsupported
ACCOUNT_STATUS_CODE is an unsupported type, check if it needs cleaning or further analysis Unsupported
ANN_PREMIUM_AMT is an unsupported type, check if it needs cleaning or further analysis Unsupported
BUSINESS_SEGMENT_1 is an unsupported type, check if it needs cleaning or further analysis Unsupported
CANCELLED_DATE is an unsupported type, check if it needs cleaning or further analysis Unsupported
CASH_SURR_VALUE is an unsupported type, check if it needs cleaning or further analysis Unsupported
COLLECTED_BALANCE is an unsupported type, check if it needs cleaning or further analysis Unsupported
COMMENTS is an unsupported type, check if it needs cleaning or further analysis Unsupported
COMPANY_NAME is an unsupported type, check if it needs cleaning or further analysis Unsupported
CUSTOMER_INITIATED_CLOSURE is an unsupported type, check if it needs cleaning or further analysis Unsupported
CUSTOMER_ID is an unsupported type, check if it needs cleaning or further analysis Unsupported
CUSTOMER_TYPE is an unsupported type, check if it needs cleaning or further analysis Unsupported
DEATH_BENEFIT_AMT is an unsupported type, check if it needs cleaning or further analysis Unsupported
DELAYED_ACCOUNT_FLAG is an unsupported type, check if it needs cleaning or further analysis Unsupported
DELIVERY_INSTRUCTIONS is an unsupported type, check if it needs cleaning or further analysis Unsupported
EMPLOYEE_NUMBER is an unsupported type, check if it needs cleaning or further analysis Unsupported
ERROR_CORRECT_FLAG is an unsupported type, check if it needs cleaning or further analysis Unsupported
GROSS_PREM_TTD is an unsupported type, check if it needs cleaning or further analysis Unsupported
HOLDING_BANK_NAME is an unsupported type, check if it needs cleaning or further analysis Unsupported
INST_PREMIUM_AMT is an unsupported type, check if it needs cleaning or further analysis Unsupported
LANGUAGE_PREF_CODE is an unsupported type, check if it needs cleaning or further analysis Unsupported
MATURITY_DATE is an unsupported type, check if it needs cleaning or further analysis Unsupported
OTHER_HOLD_AMOUNT is an unsupported type, check if it needs cleaning or further analysis Unsupported
PERSON_TITLE is an unsupported type, check if it needs cleaning or further analysis Unsupported
POSTAL_CODE is an unsupported type, check if it needs cleaning or further analysis Unsupported
PRIMARY_CARD_ID is an unsupported type, check if it needs cleaning or further analysis Unsupported
PRIMARY_CUSTOMER_CATEGORY_CODE is an unsupported type, check if it needs cleaning or further analysis Unsupported
REGISTERED_NUMBER is an unsupported type, check if it needs cleaning or further analysis Unsupported
RUN_TIMESTAMP is an unsupported type, check if it needs cleaning or further analysis Unsupported
SALARY_LODGED_FLAG is an unsupported type, check if it needs cleaning or further analysis Unsupported
SENT_CORRESPONDENCE_FLAG is an unsupported type, check if it needs cleaning or further analysis Unsupported
SETTLEMENT_BANK_NAME is an unsupported type, check if it needs cleaning or further analysis Unsupported
SETTLEMENT_TYPE is an unsupported type, check if it needs cleaning or further analysis Unsupported
SINGLE_PREMIUM_TOTAL is an unsupported type, check if it needs cleaning or further analysis Unsupported
SOURCE_SYSTEM_CODE is an unsupported type, check if it needs cleaning or further analysis Unsupported
SUB_DIVISION is an unsupported type, check if it needs cleaning or further analysis Unsupported
SUM_INSURED is an unsupported type, check if it needs cleaning or further analysis Unsupported
TO_DATE is an unsupported type, check if it needs cleaning or further analysis Unsupported
TOTAL_DEPOSITS_BASE is an unsupported type, check if it needs cleaning or further analysis Unsupported
TRANSACTION_LOCATION is an unsupported type, check if it needs cleaning or further analysis Unsupported
TURNOVER_FROM_DATE is an unsupported type, check if it needs cleaning or further analysis Unsupported
TURNOVER_TO_DATE is an unsupported type, check if it needs cleaning or further analysis Unsupported
BRANCH_ID has 445216 (87.6%) zeros Zeros
PRIME_BRANCH_ID has 448137 (88.2%) zeros Zeros
RELATIONSHIP_MGR_ID has 448137 (88.2%) zeros Zeros

Variables

ACCOUNT_BALANCE
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
0
508031
ValueCountFrequency (%) 
0508031100.0%
 

ACCOUNT_ON_HOLD_FLAG
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

ACCOUNT_PURPOSE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
DIARIO
508031
ValueCountFrequency (%) 
DIARIO508031100.0%
 

Length

Max length6
Median length6
Mean length6
Min length6

ACCOUNT_SEGMENT
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
1
508031
ValueCountFrequency (%) 
1508031100.0%
 

ACCOUNT_SOURCE_UNIQUE_ID
Categorical

UNIQUE

Distinct count508031
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
ACC-CUST-20907
 
1
ACC-CUST-1025
 
1
ACC-CUST-422374
 
1
ACC-CUST-497502
 
1
ACC-CUST-182044
 
1
Other values (508026)
508026
ValueCountFrequency (%) 
ACC-CUST-209071< 0.1%
 
ACC-CUST-10251< 0.1%
 
ACC-CUST-4223741< 0.1%
 
ACC-CUST-4975021< 0.1%
 
ACC-CUST-1820441< 0.1%
 
ACC-CUST-972421< 0.1%
 
ACC-CUST-1016931< 0.1%
 
ACC-CUST-3383291< 0.1%
 
ACC-CUST-3797991< 0.1%
 
ACC-CUST-4351971< 0.1%
 
Other values (508021)508021> 99.9%
 

Length

Max length15
Median length15
Mean length14.78348172
Min length13

ACCOUNT_STATUS_CODE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

ACQUISITION_DATE
Real number (ℝ≥0)

Distinct count50110
Unique (%)9.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26027.56291053105
Minimum2008
Maximum52117
Zeros0
Zeros (%)0.0%
Memory size3.9 MiB

Quantile statistics

Minimum2008
5-th percentile4317
Q113554
median25702
Q338403
95-th percentile48563
Maximum52117
Range50109
Interquartile range (IQR)24849

Descriptive statistics

Standard deviation14274.75535
Coefficient of variation (CV)0.548447636
Kurtosis-1.210784941
Mean26027.56291
Median Absolute Deviation (MAD)12411
Skewness0.05638853844
Sum1.322280881e+10
Variance203768640.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
204711< 0.1%
 
933811< 0.1%
 
524411< 0.1%
 
729311< 0.1%
 
319911< 0.1%
 
1778211< 0.1%
 
1368811< 0.1%
 
1573711< 0.1%
 
959411< 0.1%
 
1164311< 0.1%
 
Other values (50100)507921> 99.9%
 
ValueCountFrequency (%) 
200811< 0.1%
 
200911< 0.1%
 
201011< 0.1%
 
201111< 0.1%
 
201211< 0.1%
 
ValueCountFrequency (%) 
521175< 0.1%
 
521165< 0.1%
 
521155< 0.1%
 
521145< 0.1%
 
521135< 0.1%
 

ANN_PREMIUM_AMT
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

BALANCE_DATE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
2018
508031
ValueCountFrequency (%) 
2018508031100.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

BENEFICIARY_FLAG
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
N
508031
ValueCountFrequency (%) 
N508031100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

BLOCKED_REASON
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
HIGH ACTIVITY
508031
ValueCountFrequency (%) 
HIGH ACTIVITY508031100.0%
 

Length

Max length13
Median length13
Mean length13
Min length13

BLOCKED_TYPE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Y
508031
ValueCountFrequency (%) 
Y508031100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

BRANCH_ID
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count5
Unique (%)< 0.1%
Missing2921
Missing (%)0.6%
Infinite0
Infinite (%)0.0%
Mean0.6659242541228644
Minimum0.0
Maximum9.0
Zeros445216
Zeros (%)87.6%
Memory size3.9 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile7
Maximum9
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.045329575
Coefficient of variation (CV)3.071414748
Kurtosis8.320709105
Mean0.6659242541
Median Absolute Deviation (MAD)0
Skewness3.110155732
Sum336365
Variance4.18337307
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
044521687.6%
 
7233744.6%
 
2186243.7%
 
9127832.5%
 
451131.0%
 
(Missing)29210.6%
 
ValueCountFrequency (%) 
044521687.6%
 
2186243.7%
 
451131.0%
 
7233744.6%
 
9127832.5%
 
ValueCountFrequency (%) 
9127832.5%
 
7233744.6%
 
451131.0%
 
2186243.7%
 
044521687.6%
 

BUSINESS_SEGMENT_1
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

BUSINESS_TYPE
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Cooperative
376619
ybrid BusinessAsia
 
52266
Merchandising Business
 
51197
Service Business.
 
27949
ValueCountFrequency (%) 
Cooperative37661974.1%
 
ybrid BusinessAsia5226610.3%
 
Merchandising Business5119710.1%
 
Service Business.279495.5%
 

Length

Max length22
Median length11
Mean length13.15877181
Min length11

CANCELLED_DATE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

CASH_SURR_VALUE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

CHANNEL_OF_OPENING
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
INTERNET
508031
ValueCountFrequency (%) 
INTERNET508031100.0%
 

Length

Max length8
Median length8
Mean length8
Min length8

CHECK_ACCOUNT_NUMBER
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count72542
Unique (%)14.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11415.434400656653
Minimum1
Maximum73767
Zeros0
Zeros (%)0.0%
Memory size3.9 MiB

Quantile statistics

Minimum1
5-th percentile2
Q11234
median1234
Q310264
95-th percentile61066.5
Maximum73767
Range73766
Interquartile range (IQR)9030

Descriptive statistics

Standard deviation19932.86649
Coefficient of variation (CV)1.74613298
Kurtosis1.755315673
Mean11415.4344
Median Absolute Deviation (MAD)0
Skewness1.774092032
Sum5799394554
Variance397319166.4
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
123429075457.2%
 
2166263.3%
 
5131482.6%
 
1129632.6%
 
10105902.1%
 
1280351.6%
 
2151131.0%
 
1331770.6%
 
325580.5%
 
134293< 0.1%
 
Other values (72532)14506428.6%
 
ValueCountFrequency (%) 
1129632.6%
 
2166263.3%
 
325580.5%
 
5131482.6%
 
10105902.1%
 
ValueCountFrequency (%) 
737672< 0.1%
 
737662< 0.1%
 
737652< 0.1%
 
737642< 0.1%
 
737632< 0.1%
 

CITY
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
China
413355
Madrid
 
51695
New York
 
42981
ValueCountFrequency (%) 
China41335581.4%
 
Madrid5169510.2%
 
New York429818.5%
 

Length

Max length8
Median length5
Mean length5.355564916
Min length5

COLLECTED_BALANCE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

COMMENTS
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

COMPANY_FORM
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
SL
435526
PARTICULAR
 
28680
SA
 
23738
SC
 
8036
ASOCIACION
 
8034
Other values (2)
 
4017
ValueCountFrequency (%) 
SL43552685.7%
 
PARTICULAR286805.6%
 
SA237384.7%
 
SC80361.6%
 
ASOCIACION80341.6%
 
SSL29220.6%
 
Asociacion10950.2%
 

Length

Max length10
Median length2
Mean length2.601132608
Min length2

COMPANY_NAME
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

COUNTRY_OF_ORIGIN
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
China
413355
Spain
 
51695
EEUU
 
42981
ValueCountFrequency (%) 
China41335581.4%
 
Spain5169510.2%
 
EEUU429818.5%
 

Length

Max length5
Median length5
Mean length4.915396895
Min length4

COUNTRY_OF_RESIDENCE
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
China
413355
Spain
 
51695
Mexico
 
42981
ValueCountFrequency (%) 
China41335581.4%
 
Spain5169510.2%
 
Mexico429818.5%
 

Length

Max length6
Median length5
Mean length5.084603105
Min length5
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
C
507665
D
 
366
ValueCountFrequency (%) 
C50766599.9%
 
D3660.1%
 

Length

Max length1
Median length1
Mean length1
Min length1

CREDIT_LIMIT
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
2000
508031
ValueCountFrequency (%) 
2000508031100.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

CREDIT_TURNOVER
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Y
508031
ValueCountFrequency (%) 
Y508031100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

CURRENCY_CODE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
EUR
508031
ValueCountFrequency (%) 
EUR508031100.0%
 

Length

Max length3
Median length3
Mean length3
Min length3
Distinct count3
Unique (%)< 0.1%
Missing2921
Missing (%)0.6%
Memory size3.9 MiB
EUR
414161
DOL
90583
GBR
 
366
ValueCountFrequency (%) 
EUR41416181.5%
 
DOL9058317.8%
 
GBR3660.1%
 
(Missing)29210.6%
 

Length

Max length3
Median length3
Mean length3
Min length3
Distinct count3
Unique (%)< 0.1%
Missing2921
Missing (%)0.6%
Memory size3.9 MiB
EUR
395901
DOL
102635
GBR
 
6574
ValueCountFrequency (%) 
EUR39590177.9%
 
DOL10263520.2%
 
GBR65741.3%
 
(Missing)29210.6%
 

Length

Max length3
Median length3
Mean length3
Min length3

CUSTOMER_INITIATED_CLOSURE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

CUSTOMER_SEGMENT_1
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
1
508031
ValueCountFrequency (%) 
1508031100.0%
 
Distinct count17
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
CUSTTM-0014
 
48384
CUSTTM-0002
 
48384
CUSTTM-0003
 
48384
CUSTTM-0001
 
48384
CUSTTM-0017
 
48384
Other values (12)
266111
ValueCountFrequency (%) 
CUSTTM-0014483849.5%
 
CUSTTM-0002483849.5%
 
CUSTTM-0003483849.5%
 
CUSTTM-0001483849.5%
 
CUSTTM-0017483849.5%
 
CUSTTM-0007483849.5%
 
CUSTTM-0006483849.5%
 
CUSTTM-0015483849.5%
 
CUSTTM-0016241924.8%
 
CUSTTM-0012120962.4%
 
Other values (7)8467116.7%
 

Length

Max length11
Median length11
Mean length11
Min length11

CUSTOMER_ID
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

CUSTOMER_STATUS_CODE
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
1
508031
ValueCountFrequency (%) 
1508031100.0%
 

CUSTOMER_TYPE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

CUSTOMER_TYPE_CODE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
P
508031
ValueCountFrequency (%) 
P508031100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

DATE_CLOSED
Categorical

HIGH CORRELATION

Distinct count4
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size3.9 MiB
01/01/2010
507932
03/01/2010
 
33
04/01/2010
 
33
02/01/2010
 
32
ValueCountFrequency (%) 
01/01/2010507932> 99.9%
 
03/01/201033< 0.1%
 
04/01/201033< 0.1%
 
02/01/201032< 0.1%
 
(Missing)1< 0.1%
 

Length

Max length10
Median length10
Mean length9.999986221
Min length3

DATE_OPENED
Categorical

HIGH CORRELATION

Distinct count4
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size3.9 MiB
01/01/2010
507932
03/01/2010
 
33
04/01/2010
 
33
02/01/2010
 
32
ValueCountFrequency (%) 
01/01/2010507932> 99.9%
 
03/01/201033< 0.1%
 
04/01/201033< 0.1%
 
02/01/201032< 0.1%
 
(Missing)1< 0.1%
 

Length

Max length10
Median length10
Mean length9.999986221
Min length3

DEATH_BENEFIT_AMT
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

DEBIT_TRUNOVER
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
N
508031
ValueCountFrequency (%) 
N508031100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

DELAYED_ACCOUNT_FLAG
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

DELIVERY_INSTRUCTIONS
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

DEVICE_ID
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Web
408321
App
 
77433
ATM
 
20816
Mobile
 
730
Branch
 
366
ValueCountFrequency (%) 
Web40832180.4%
 
App7743315.2%
 
ATM208164.1%
 
Mobile7300.1%
 
Branch3660.1%
 
83650.1%
 

Length

Max length6
Median length3
Mean length3.005035126
Min length1
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
N
456336
Y
 
51695
ValueCountFrequency (%) 
N45633689.8%
 
Y5169510.2%
 

EMPLOYEE_NUMBER
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

EMPLOYMENT_STATUS
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Desempleado
508031
ValueCountFrequency (%) 
Desempleado508031100.0%
 

Length

Max length11
Median length11
Mean length11
Min length11

ERROR_CORRECT_FLAG
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

FILTER
Real number (ℝ≥0)

Distinct count17
Unique (%)< 0.1%
Missing2922
Missing (%)0.6%
Infinite0
Infinite (%)0.0%
Mean2031.5881384018103
Minimum2020.0
Maximum2042.0
Zeros0
Zeros (%)0.0%
Memory size3.9 MiB

Quantile statistics

Minimum2020
5-th percentile2021
Q12028
median2033
Q32038
95-th percentile2042
Maximum2042
Range22
Interquartile range (IQR)10

Descriptive statistics

Standard deviation7.139984691
Coefficient of variation (CV)0.003514484337
Kurtosis-1.178660127
Mean2031.588138
Median Absolute Deviation (MAD)5
Skewness-0.3169608147
Sum1026173453
Variance50.97938138
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
202112086123.8%
 
2042279335.5%
 
2029255115.0%
 
2041252545.0%
 
2036252545.0%
 
2032252545.0%
 
2030251855.0%
 
2031251855.0%
 
2033251855.0%
 
2034251855.0%
 
Other values (7)15430230.4%
 
ValueCountFrequency (%) 
202033150.7%
 
202112086123.8%
 
2028250624.9%
 
2029255115.0%
 
2030251855.0%
 
ValueCountFrequency (%) 
2042279335.5%
 
2041252545.0%
 
2040251855.0%
 
2039251855.0%
 
2038251855.0%
 

FROM_DATE
Categorical

Distinct count1
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size3.9 MiB
01/01/2009
508030
ValueCountFrequency (%) 
01/01/2009508030> 99.9%
 
(Missing)1< 0.1%
 

Length

Max length10
Median length10
Mean length9.999986221
Min length3

GENDER_CODE
Categorical

HIGH CORRELATION
MISSING

Distinct count2
Unique (%)< 0.1%
Missing54847
Missing (%)10.8%
Memory size3.9 MiB
M
400027
H
 
53157
ValueCountFrequency (%) 
M40002778.7%
 
H5315710.5%
 
(Missing)5484710.8%
 

Length

Max length3
Median length1
Mean length1.215919895
Min length1

GROSS_PREM_TTD
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

HOLDING_BANK_NAME
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB
Distinct count12
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size3.9 MiB
ESP
461647
UK
 
8035
GER
 
8034
FR
 
6574
SUE
 
5113
Other values (7)
 
18627
ValueCountFrequency (%) 
ESP46164790.9%
 
UK80351.6%
 
GER80341.6%
 
FR65741.3%
 
SUE51131.0%
 
IQ51131.0%
 
IR51131.0%
 
POR43820.9%
 
IT10960.2%
 
EEUU10960.2%
 
Other values (2)18270.4%
 

Length

Max length4
Median length3
Mean length2.951115188
Min length2
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
01/01/2009
508030
0:00:00
 
1
ValueCountFrequency (%) 
01/01/2009508030> 99.9%
 
0:00:001< 0.1%
 

Length

Max length10
Median length10
Mean length9.999994095
Min length7

INST_PREMIUM_AMT
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

ISSUE_DATE
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count24217
Unique (%)4.8%
Missing1
Missing (%)< 0.1%
Memory size3.9 MiB
13/03/2010
 
21
25/06/2004
 
21
14/03/2050
 
21
12/08/2052
 
21
10/08/2049
 
21
Other values (24212)
507925
ValueCountFrequency (%) 
13/03/201021< 0.1%
 
25/06/200421< 0.1%
 
14/03/205021< 0.1%
 
12/08/205221< 0.1%
 
10/08/204921< 0.1%
 
17/12/206321< 0.1%
 
08/06/202721< 0.1%
 
18/02/201221< 0.1%
 
17/09/202021< 0.1%
 
01/07/201121< 0.1%
 
Other values (24207)507820> 99.9%
 

Length

Max length10
Median length10
Mean length9.999986221
Min length3

LANGUAGE_PREF_CODE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

LIFE_INS_CONTRACT_DURATION
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
0
508031
ValueCountFrequency (%) 
0508031100.0%
 

MATURITY_DATE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

OCCUPATION
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Camarero
508031
ValueCountFrequency (%) 
Camarero508031100.0%
 

Length

Max length8
Median length8
Mean length8
Min length8

ORG_UNIT_CODE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
RET
508031
ValueCountFrequency (%) 
RET508031100.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

ORIGINATION_DATE
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count24218
Unique (%)4.8%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
13/03/2010
 
21
29/05/2007
 
21
07/10/2067
 
21
28/02/2015
 
21
09/09/2055
 
21
Other values (24213)
507926
ValueCountFrequency (%) 
13/03/201021< 0.1%
 
29/05/200721< 0.1%
 
07/10/206721< 0.1%
 
28/02/201521< 0.1%
 
09/09/205521< 0.1%
 
19/05/203421< 0.1%
 
18/11/205421< 0.1%
 
17/10/205421< 0.1%
 
08/05/204621< 0.1%
 
29/06/201721< 0.1%
 
Other values (24208)507821> 99.9%
 

Length

Max length10
Median length10
Mean length9.999994095
Min length7

OTHER_HOLD_AMOUNT
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

OVERDRAFT_LIMIT
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
0
508031
ValueCountFrequency (%) 
0508031100.0%
 

PAYMENT_FREQ
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Diario
508031
ValueCountFrequency (%) 
Diario508031100.0%
 

Length

Max length6
Median length6
Mean length6
Min length6

PAYMENT_METHOD
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Transferencia
508031
ValueCountFrequency (%) 
Transferencia508031100.0%
 

Length

Max length13
Median length13
Mean length13
Min length13

PERIODIC_LOAN_AMOUNT
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
0
508031
ValueCountFrequency (%) 
0508031100.0%
 

PERSON_TITLE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

POSTAL_CODE
Unsupported

REJECTED
UNSUPPORTED

Missing0
Missing (%)0.0%
Memory size3.9 MiB

PRIMARY_CARD_ID
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

PRIMARY_CUSTOMER_CATEGORY_CODE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

PRIME_BRANCH_ID
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.6620954233107822
Minimum0
Maximum9
Zeros448137
Zeros (%)88.2%
Memory size3.9 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile7
Maximum9
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.040062536
Coefficient of variation (CV)3.081221323
Kurtosis8.39578829
Mean0.6620954233
Median Absolute Deviation (MAD)0
Skewness3.121716638
Sum336365
Variance4.161855152
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
044813788.2%
 
7233744.6%
 
2186243.7%
 
9127832.5%
 
451131.0%
 
ValueCountFrequency (%) 
044813788.2%
 
2186243.7%
 
451131.0%
 
7233744.6%
 
9127832.5%
 
ValueCountFrequency (%) 
9127832.5%
 
7233744.6%
 
451131.0%
 
2186243.7%
 
044813788.2%
 

PRODUCT_SOURCE_TYPE_CODE
Categorical

HIGH CARDINALITY

Distinct count10966
Unique (%)2.2%
Missing2921
Missing (%)0.6%
Memory size3.9 MiB
TT0001
 
25620
8
 
10956
5
 
8765
2
 
7669
7
 
6210
Other values (10961)
445890
ValueCountFrequency (%) 
TT0001256205.0%
 
8109562.2%
 
587651.7%
 
276691.5%
 
762101.2%
 
654781.1%
 
451131.0%
 
951131.0%
 
147470.9%
 
000529440.6%
 
Other values (10956)42249583.2%
 
(Missing)29210.6%
 

Length

Max length6
Median length6
Mean length5.161759814
Min length1

REGISTERED_NUMBER
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

RELATIONSHIP_MGR_ID
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.6620954233107822
Minimum0
Maximum9
Zeros448137
Zeros (%)88.2%
Memory size3.9 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile7
Maximum9
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.040062536
Coefficient of variation (CV)3.081221323
Kurtosis8.39578829
Mean0.6620954233
Median Absolute Deviation (MAD)0
Skewness3.121716638
Sum336365
Variance4.161855152
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
044813788.2%
 
7233744.6%
 
2186243.7%
 
9127832.5%
 
451131.0%
 
ValueCountFrequency (%) 
044813788.2%
 
2186243.7%
 
451131.0%
 
7233744.6%
 
9127832.5%
 
ValueCountFrequency (%) 
9127832.5%
 
7233744.6%
 
451131.0%
 
2186243.7%
 
044813788.2%
 

REPORTING_REGION
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Y
508031
ValueCountFrequency (%) 
Y508031100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

RISK_CATEGORY
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
PEP
508031
ValueCountFrequency (%) 
PEP508031100.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

RISK_SCORE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
100
508031
ValueCountFrequency (%) 
100508031100.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

RUN_TIMESTAMP
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SALARY_LODGED_FLAG
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SENT_CORRESPONDENCE_FLAG
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SETTLEMENT_BANK_NAME
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SETTLEMENT_TYPE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SINGLE_PREMIUM_TOTAL
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SOURCE_SYSTEM_CODE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SOURCE_TXN_NUM
Categorical

UNIQUE

Distinct count508031
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
TXN-CUSTTM-292260
 
1
TXN-CUSTTM-55885
 
1
TXN-CUSTTM-167210
 
1
TXN-CUSTTM-297336
 
1
TXN-CUSTTM-391351
 
1
Other values (508026)
508026
ValueCountFrequency (%) 
TXN-CUSTTM-2922601< 0.1%
 
TXN-CUSTTM-558851< 0.1%
 
TXN-CUSTTM-1672101< 0.1%
 
TXN-CUSTTM-2973361< 0.1%
 
TXN-CUSTTM-3913511< 0.1%
 
TXN-CUSTTM-4865161< 0.1%
 
TXN-CUSTTM-1420911< 0.1%
 
TXN-CUSTTM-4971611< 0.1%
 
TXN-CUSTTM-4982881< 0.1%
 
TXN-CUSTTM-4402541< 0.1%
 
Other values (508021)508021> 99.9%
 

Length

Max length17
Median length17
Mean length16.78348172
Min length15

SOURCE_TXN_UNIQUE_ID
Categorical

UNIQUE

Distinct count508031
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
TXN-CUSTTM-292260
 
1
TXN-CUSTTM-55885
 
1
TXN-CUSTTM-167210
 
1
TXN-CUSTTM-297336
 
1
TXN-CUSTTM-391351
 
1
Other values (508026)
508026
ValueCountFrequency (%) 
TXN-CUSTTM-2922601< 0.1%
 
TXN-CUSTTM-558851< 0.1%
 
TXN-CUSTTM-1672101< 0.1%
 
TXN-CUSTTM-2973361< 0.1%
 
TXN-CUSTTM-3913511< 0.1%
 
TXN-CUSTTM-4865161< 0.1%
 
TXN-CUSTTM-1420911< 0.1%
 
TXN-CUSTTM-4971611< 0.1%
 
TXN-CUSTTM-4982881< 0.1%
 
TXN-CUSTTM-4402541< 0.1%
 
Other values (508021)508021> 99.9%
 

Length

Max length17
Median length17
Mean length16.78348172
Min length15

SUB_DIVISION
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

SUM_INSURED
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

TO_DATE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

TOTAL_DEPOSITS_BASE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

TOTAL_LOANS_BASE
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
200
508031
ValueCountFrequency (%) 
200508031100.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

TRANSACTION_LOCATION
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

TURNOVER_FROM_DATE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

TURNOVER_TO_DATE
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing508031
Missing (%)100.0%
Memory size3.9 MiB

TXN_AMOUNT_ORIG
Real number (ℝ≥0)

Distinct count72539
Unique (%)14.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9874.674927317428
Minimum1
Maximum73784
Zeros0
Zeros (%)0.0%
Memory size3.9 MiB

Quantile statistics

Minimum1
5-th percentile1000
Q13000
median3000
Q310000
95-th percentile48382.5
Maximum73784
Range73783
Interquartile range (IQR)7000

Descriptive statistics

Standard deviation14728.85146
Coefficient of variation (CV)1.491578363
Kurtosis6.005497049
Mean9874.674927
Median Absolute Deviation (MAD)1749
Skewness2.527601214
Sum5016640978
Variance216939065.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
300020473740.3%
 
10005341510.5%
 
1251325806.4%
 
9000102312.0%
 
800090681.8%
 
678980411.6%
 
1000053751.1%
 
500051201.0%
 
459951201.0%
 
129210.6%
 
Other values (72529)17142333.7%
 
ValueCountFrequency (%) 
129210.6%
 
9992570.1%
 
10005341510.5%
 
10015140.1%
 
12492570.1%
 
ValueCountFrequency (%) 
737841< 0.1%
 
737831< 0.1%
 
737821< 0.1%
 
737811< 0.1%
 
737801< 0.1%
 

TXN_CHANNEL_CODE
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count72536
Unique (%)14.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10360.240241245121
Minimum1
Maximum72537
Zeros0
Zeros (%)0.0%
Memory size3.9 MiB

Quantile statistics

Minimum1
5-th percentile4
Q14
median4
Q39034
95-th percentile59836.5
Maximum72537
Range72536
Interquartile range (IQR)9030

Descriptive statistics

Standard deviation19837.20974
Coefficient of variation (CV)1.914744184
Kurtosis1.778753579
Mean10360.24024
Median Absolute Deviation (MAD)0
Skewness1.781279239
Sum5263323210
Variance393514890.4
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
429111957.3%
 
7504839.9%
 
894991.9%
 
251111.0%
 
141980.8%
 
514640.3%
 
610980.2%
 
121993< 0.1%
 
228782< 0.1%
 
269682< 0.1%
 
Other values (72526)14505228.6%
 
ValueCountFrequency (%) 
141980.8%
 
251111.0%
 
429111957.3%
 
514640.3%
 
610980.2%
 
ValueCountFrequency (%) 
725372< 0.1%
 
725362< 0.1%
 
725352< 0.1%
 
725342< 0.1%
 
725332< 0.1%
 

TXN_SOURCE_TYPE_CODE
Categorical

HIGH CARDINALITY

Distinct count9030
Unique (%)1.8%
Missing2921
Missing (%)0.6%
Memory size3.9 MiB
TT001
 
43150
TT002
 
10287
TT005
 
8096
TT008
 
5174
6
 
5113
Other values (9025)
433290
ValueCountFrequency (%) 
TT001431508.5%
 
TT002102872.0%
 
TT00580961.6%
 
TT00851741.0%
 
651131.0%
 
529210.6%
 
429210.6%
 
TT00243930.1%
 
TT00283910.1%
 
TT00303900.1%
 
Other values (9020)42627483.9%
 
(Missing)29210.6%
 

Length

Max length6
Median length6
Mean length5.625479548
Min length1

TXN_STATUS_CODE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
ACTIVE
503283
INACTIVE
 
4383
INACT
 
365
ValueCountFrequency (%) 
ACTIVE50328399.1%
 
INACTIVE43830.9%
 
INACT3650.1%
 

Length

Max length8
Median length6
Mean length6.016536392
Min length5

ZONE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 MiB
Asia
411355
EEUU
 
51197
Europe
 
45479
ValueCountFrequency (%) 
Asia41135581.0%
 
EEUU5119710.1%
 
Europe454799.0%
 

Length

Max length6
Median length4
Mean length4.179040255
Min length4

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

ACCOUNT_BALANCEACCOUNT_ON_HOLD_FLAGACCOUNT_PURPOSEACCOUNT_SEGMENTACCOUNT_SOURCE_UNIQUE_IDACCOUNT_STATUS_CODEACQUISITION_DATEANN_PREMIUM_AMTBALANCE_DATEBENEFICIARY_FLAGBLOCKED_REASONBLOCKED_TYPEBRANCH_IDBUSINESS_SEGMENT_1BUSINESS_TYPECANCELLED_DATECASH_SURR_VALUECHANNEL_OF_OPENINGCHECK_ACCOUNT_NUMBERCITYCOLLECTED_BALANCECOMMENTSCOMPANY_FORMCOMPANY_NAMECOUNTRY_OF_ORIGINCOUNTRY_OF_RESIDENCECREDIT_DEBIT_CODECREDIT_LIMITCREDIT_TURNOVERCURRENCY_CODECURRENCY_CODE_BASECURRENCY_CODE_ORIGCUSTOMER_INITIATED_CLOSURECUSTOMER_SEGMENT_1CUSTOMER_SOURCE_UNIQUE_IDCUSTOMER_IDCUSTOMER_STATUS_CODECUSTOMER_TYPECUSTOMER_TYPE_CODEDATE_CLOSEDDATE_OPENEDDEATH_BENEFIT_AMTDEBIT_TRUNOVERDELAYED_ACCOUNT_FLAGDELIVERY_INSTRUCTIONSDEVICE_IDEMPLOYEE_FLAGEMPLOYEE_NUMBEREMPLOYMENT_STATUSERROR_CORRECT_FLAGFILTERFROM_DATEGENDER_CODEGROSS_PREM_TTDHOLDING_BANK_NAMEINCORPORATION_COUNTRY_CODEINCORPORATION_DATEINST_PREMIUM_AMTISSUE_DATELANGUAGE_PREF_CODELIFE_INS_CONTRACT_DURATIONMATURITY_DATEOCCUPATIONORG_UNIT_CODEORIGINATION_DATEOTHER_HOLD_AMOUNTOVERDRAFT_LIMITPAYMENT_FREQPAYMENT_METHODPERIODIC_LOAN_AMOUNTPERSON_TITLEPOSTAL_CODEPRIMARY_CARD_IDPRIMARY_CUSTOMER_CATEGORY_CODEPRIME_BRANCH_IDPRODUCT_SOURCE_TYPE_CODEREGISTERED_NUMBERRELATIONSHIP_MGR_IDREPORTING_REGIONRISK_CATEGORYRISK_SCORERUN_TIMESTAMPSALARY_LODGED_FLAGSENT_CORRESPONDENCE_FLAGSETTLEMENT_BANK_NAMESETTLEMENT_TYPESINGLE_PREMIUM_TOTALSOURCE_SYSTEM_CODESOURCE_TXN_NUMSOURCE_TXN_UNIQUE_IDSUB_DIVISIONSUM_INSUREDTO_DATETOTAL_DEPOSITS_BASETOTAL_LOANS_BASETRANSACTION_LOCATIONTURNOVER_FROM_DATETURNOVER_TO_DATETXN_AMOUNT_ORIGTXN_CHANNEL_CODETXN_SOURCE_TYPE_CODETXN_STATUS_CODEZONE
00NaNDIARIO1ACC-CUST-0001NaN2008NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0014NaN1NaNP03/01/201003/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN04/03/2004NaN0NaNCamareroRET04/03/2004NaN0DiarioTransferencia0NaN28028NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0001TXN-CUSTTM-0001NaNNaNNaNNaN200NaNNaNNaN10005TT0024INACTIVEEurope
10NaNDIARIO1ACC-CUST-0002NaN2009NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0014NaN1NaNP04/01/201004/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN05/03/2004NaN0NaNCamareroRET05/03/2004NaN0DiarioTransferencia0NaN28029NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0002TXN-CUSTTM-0002NaNNaNNaNNaN200NaNNaNNaN30005TT0024INACTIVEEurope
20NaNDIARIO1ACC-CUST-0003NaN2010NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0014NaN1NaNP01/01/201001/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN06/03/2004NaN0NaNCamareroRET06/03/2004NaN0DiarioTransferencia0NaN28030NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0003TXN-CUSTTM-0003NaNNaNNaNNaN200NaNNaNNaN10005TT0024INACTIVEEurope
30NaNDIARIO1ACC-CUST-0004NaN2011NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0014NaN1NaNP02/01/201002/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN07/03/2004NaN0NaNCamareroRET07/03/2004NaN0DiarioTransferencia0NaN28031NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0004TXN-CUSTTM-0004NaNNaNNaNNaN200NaNNaNNaN10015TT0024INACTIVEEurope
40NaNDIARIO1ACC-CUST-0005NaN2012NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0015NaN1NaNP03/01/201003/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN08/03/2004NaN0NaNCamareroRET08/03/2004NaN0DiarioTransferencia0NaN28032NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0005TXN-CUSTTM-0005NaNNaNNaNNaN200NaNNaNNaN10005TT0024INACTIVEEurope
50NaNDIARIO1ACC-CUST-0006NaN2013NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0015NaN1NaNP04/01/201004/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN09/03/2004NaN0NaNCamareroRET09/03/2004NaN0DiarioTransferencia0NaN28033NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0006TXN-CUSTTM-0006NaNNaNNaNNaN200NaNNaNNaN30005TT0024INACTIVEEurope
60NaNDIARIO1ACC-CUST-0007NaN2014NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0015NaN1NaNP01/01/201001/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN10/03/2004NaN0NaNCamareroRET10/03/2004NaN0DiarioTransferencia0NaN28034NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0007TXN-CUSTTM-0007NaNNaNNaNNaN200NaNNaNNaN10005TT0024INACTIVEEurope
70NaNDIARIO1ACC-CUST-0008NaN2015NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0015NaN1NaNP01/01/201001/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN11/03/2004NaN0NaNCamareroRET11/03/2004NaN0DiarioTransferencia0NaN28035NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0008TXN-CUSTTM-0008NaNNaNNaNNaN200NaNNaNNaN9995TT0024INACTIVEEurope
80NaNDIARIO1ACC-CUST-0009NaN2016NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0016NaN1NaNP01/01/201001/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN12/03/2004NaN0NaNCamareroRET12/03/2004NaN0DiarioTransferencia0NaN28036NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0009TXN-CUSTTM-0009NaNNaNNaNNaN200NaNNaNNaN100005TT0024INACTIVEEurope
90NaNDIARIO1ACC-CUST-0010NaN2017NaN2018NHIGH ACTIVITYY0.0NaNCooperativeNaNNaNINTERNET1234MadridNaNNaNPARTICULARNaNSpainSpainD2000YEURDOLDOLNaN1CUSTTM-0016NaN1NaNP02/01/201002/01/2010NaNNNaNNaNATMYNaNDesempleadoNaNNaN01/01/2009HNaNNaNESP01/01/2009NaN13/03/2004NaN0NaNCamareroRET13/03/2004NaN0DiarioTransferencia0NaN28037NaNNaN00002NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-0010TXN-CUSTTM-0010NaNNaNNaNNaN200NaNNaNNaN50015TT0024INACTIVEEurope

Last rows

ACCOUNT_BALANCEACCOUNT_ON_HOLD_FLAGACCOUNT_PURPOSEACCOUNT_SEGMENTACCOUNT_SOURCE_UNIQUE_IDACCOUNT_STATUS_CODEACQUISITION_DATEANN_PREMIUM_AMTBALANCE_DATEBENEFICIARY_FLAGBLOCKED_REASONBLOCKED_TYPEBRANCH_IDBUSINESS_SEGMENT_1BUSINESS_TYPECANCELLED_DATECASH_SURR_VALUECHANNEL_OF_OPENINGCHECK_ACCOUNT_NUMBERCITYCOLLECTED_BALANCECOMMENTSCOMPANY_FORMCOMPANY_NAMECOUNTRY_OF_ORIGINCOUNTRY_OF_RESIDENCECREDIT_DEBIT_CODECREDIT_LIMITCREDIT_TURNOVERCURRENCY_CODECURRENCY_CODE_BASECURRENCY_CODE_ORIGCUSTOMER_INITIATED_CLOSURECUSTOMER_SEGMENT_1CUSTOMER_SOURCE_UNIQUE_IDCUSTOMER_IDCUSTOMER_STATUS_CODECUSTOMER_TYPECUSTOMER_TYPE_CODEDATE_CLOSEDDATE_OPENEDDEATH_BENEFIT_AMTDEBIT_TRUNOVERDELAYED_ACCOUNT_FLAGDELIVERY_INSTRUCTIONSDEVICE_IDEMPLOYEE_FLAGEMPLOYEE_NUMBEREMPLOYMENT_STATUSERROR_CORRECT_FLAGFILTERFROM_DATEGENDER_CODEGROSS_PREM_TTDHOLDING_BANK_NAMEINCORPORATION_COUNTRY_CODEINCORPORATION_DATEINST_PREMIUM_AMTISSUE_DATELANGUAGE_PREF_CODELIFE_INS_CONTRACT_DURATIONMATURITY_DATEOCCUPATIONORG_UNIT_CODEORIGINATION_DATEOTHER_HOLD_AMOUNTOVERDRAFT_LIMITPAYMENT_FREQPAYMENT_METHODPERIODIC_LOAN_AMOUNTPERSON_TITLEPOSTAL_CODEPRIMARY_CARD_IDPRIMARY_CUSTOMER_CATEGORY_CODEPRIME_BRANCH_IDPRODUCT_SOURCE_TYPE_CODEREGISTERED_NUMBERRELATIONSHIP_MGR_IDREPORTING_REGIONRISK_CATEGORYRISK_SCORERUN_TIMESTAMPSALARY_LODGED_FLAGSENT_CORRESPONDENCE_FLAGSETTLEMENT_BANK_NAMESETTLEMENT_TYPESINGLE_PREMIUM_TOTALSOURCE_SYSTEM_CODESOURCE_TXN_NUMSOURCE_TXN_UNIQUE_IDSUB_DIVISIONSUM_INSUREDTO_DATETOTAL_DEPOSITS_BASETOTAL_LOANS_BASETRANSACTION_LOCATIONTURNOVER_FROM_DATETURNOVER_TO_DATETXN_AMOUNT_ORIGTXN_CHANNEL_CODETXN_SOURCE_TYPE_CODETXN_STATUS_CODEZONE
5080210NaNDIARIO1ACC-CUST-508022NaN19069NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73758New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0002NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN03/01/2069NaN0NaNCamareroRET03/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0318NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508022TXN-CUSTTM-508022NaNNaNNaNNaN200NaNNaNNaN660472528TT318ACTIVEEEUU
5080220NaNDIARIO1ACC-CUST-508023NaN19070NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73759New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0002NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN04/01/2069NaN0NaNCamareroRET04/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0319NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508023TXN-CUSTTM-508023NaNNaNNaNNaN200NaNNaNNaN660572529TT319ACTIVEEEUU
5080230NaNDIARIO1ACC-CUST-508024NaN19071NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73760New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0003NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN05/01/2069NaN0NaNCamareroRET05/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0320NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508024TXN-CUSTTM-508024NaNNaNNaNNaN200NaNNaNNaN660672530TT320ACTIVEEEUU
5080240NaNDIARIO1ACC-CUST-508025NaN19072NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73761New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0003NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN06/01/2069NaN0NaNCamareroRET06/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0321NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508025TXN-CUSTTM-508025NaNNaNNaNNaN200NaNNaNNaN660772531TT321ACTIVEEEUU
5080250NaNDIARIO1ACC-CUST-508026NaN19073NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73762New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0003NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN07/01/2069NaN0NaNCamareroRET07/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0322NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508026TXN-CUSTTM-508026NaNNaNNaNNaN200NaNNaNNaN660872532TT322ACTIVEEEUU
5080260NaNDIARIO1ACC-CUST-508027NaN19074NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73763New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0003NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN08/01/2069NaN0NaNCamareroRET08/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0323NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508027TXN-CUSTTM-508027NaNNaNNaNNaN200NaNNaNNaN660972533TT323ACTIVEEEUU
5080270NaNDIARIO1ACC-CUST-508028NaN19075NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73764New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0004NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN09/01/2069NaN0NaNCamareroRET09/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0324NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508028TXN-CUSTTM-508028NaNNaNNaNNaN200NaNNaNNaN661072534TT324ACTIVEEEUU
5080280NaNDIARIO1ACC-CUST-508029NaN19076NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73765New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0010NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN10/01/2069NaN0NaNCamareroRET10/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0325NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508029TXN-CUSTTM-508029NaNNaNNaNNaN200NaNNaNNaN661172535TT325ACTIVEEEUU
5080290NaNDIARIO1ACC-CUST-508030NaN19077NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73766New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0011NaN1NaNP01/01/201001/01/2010NaNNNaNNaNWebNNaNDesempleadoNaN2029.001/01/2009NaNNaNNaNESP01/01/2009NaN11/01/2069NaN0NaNCamareroRET11/01/2069NaN0DiarioTransferencia0NaN1001NaNNaN0TT0326NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508030TXN-CUSTTM-508030NaNNaNNaNNaN200NaNNaNNaN661272536TT326ACTIVEEEUU
5080300NaNDIARIO1ACC-CUST-508031NaN19078NaN2018NHIGH ACTIVITYY0.0NaNMerchandising BusinessNaNNaNINTERNET73767New YorkNaNNaNSLNaNEEUUMexicoC2000YEUREUREURNaN1CUSTTM-0012NaN1NaNPNaNNaNNaNNNaNNaNWebNNaNDesempleadoNaN2029.0NaNNaNNaNNaNESP0:00:00NaNNaNNaN0NaNCamareroRET0:00:00NaN0DiarioTransferencia0NaN1001NaNNaN0TT0327NaN0YPEP100NaNNaNNaNNaNNaNNaNNaNTXN-CUSTTM-508031TXN-CUSTTM-508031NaNNaNNaNNaN200NaNNaNNaN661372537TT327ACTIVEEEUU